create table qrtz_simple_triggers
(
    sched_name      nvarchar(120) not null,
    trigger_name    nvarchar(200) not null,
    trigger_group   nvarchar(200) not null,
    repeat_count    bigint        not null,
    repeat_interval bigint        not null,
    times_triggered bigint        not null,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_simple_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers
)
go

exec sp_addextendedproperty 'MS_Description', '简单触发器的信息表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simple_triggers'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simple_triggers', 'COLUMN',
     'sched_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_name的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simple_triggers', 'COLUMN', 'trigger_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_group的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simple_triggers', 'COLUMN', 'trigger_group'
go

exec sp_addextendedproperty 'MS_Description', '重复的次数统计', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simple_triggers', 'COLUMN',
     'repeat_count'
go

exec sp_addextendedproperty 'MS_Description', '重复的间隔时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simple_triggers', 'COLUMN',
     'repeat_interval'
go

exec sp_addextendedproperty 'MS_Description', '已经触发的次数', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simple_triggers', 'COLUMN',
     'times_triggered'
go

